Inside FileFlex

Table of Contents

[Click for Collapsed Table of Contents]

• About FileFlex
• Must Read: FileFlex Support
  • FileFlex Headquarters on the Web
  • The FileFlex Mailing List
  • Online Service Support Forums
  • How to Get Technical Support

---

Section I: Learning About FileFlex

• 1. Introducing FileFlex
  • FileFlex 2.0 Features and Benefits
  • FileFlex Lite Edition
  • FileFlex Professional Edition
  • FileFlex System Capacities
  • The Difference Between FileFlex and a Full DBMS
  • Interfacing FileFlex to Host Environments
  • FileFlex/ODBC Gateway
    
    
• 2. FileFlex Release Notes
  • FileFlex 2.0.3 Release Notes
  • FileFlex 2.0.2 Release Notes
  • FileFlex 2.0.1 Release Notes
  • FileFlex 2.0 Release Notes
  • FileFlex 1.7.1 to 1.7.4 Fix Notes
  • FileFlex 1.7 Release Notes
  • FileFlex 1.6 Release Notes
  • FileFlex 1.5 Release Notes
    
    
• 3. Interacting with FileFlex
  • Wrapper Scripts
  • FileFlex Has Its Own Data Files
  • xBASE Standard Data File Formats
  • FileFlex Data Types
  • Managing Multimedia Data
  • How Does "Relational" Work?
  • Calling FileFlex

---

Section II: Interfacing FileFlex

• 4. FileFlex and Director 5
  • Database Access in Director
  • Designing Databases for Use in Director Productions
  • Using FileFlex with Director 5
  • FileFlex Adds Database Commands to Lingo
  • Cross Platform Considerations
  • Installing FileFlex Files
  • Upgrading from Earlier FileFlex Releases
  • A Sample Lingo Session with FileFlex
    
    
• 5. Using FileFlex with FoxPro
  • Embedded Database for Multimedia
  • Transparent Access to PC Data
  • Programming in the Language of Your Choice
  • FoxPro <-> FileFlex DBF File Compatibility
  • FoxPro <-> FileFlex Memo File Compatibility
  • Text-Only Memo Fields
  • Create Your Databases in FileFlex
  • SET COMPATIBLE FOXPLUS
  • Converting to FileFlex Memo Files
  • Index File Compatibility
  
  
• 6. Using FileFlex in XFCN Environments
  • The FileFlex "Wrapper"Mechanism
  • General Compatibility Issues
  • Using FileFlex with Director 4
  • Using FileFlex with HyperCard
  • Using FileFlex with Authorware Professional
  • Using FileFlex with UserLand Frontier/Aretha
  • Using FileFlex with SuperCard 2.x
  • Installing XFCN-Based FileFlex

---

Section III: Using FileFlex

• 7. Initiating FileFlex Operations
  
  
• 8. Creating Data Files
  • Using the FileFlex Database Designer
  • Executing the DBCreate Function
  • Describing the Database
    
    
• 9. Managing Data Files
  • Opening and Selecting Database Files
  • Default File Paths
  • Navigating in the Database
    
    
• 10. Reading Data from a Database File
  • Retrieving a Field by Name or Number
  • Reading a Record into a Container
  • Retrieving a Memo Field
  • Retrieving a Record into Global Variables
  • Reading a Record into a Card
    
    
• 11. Adding and Updating Data
  • Changing Field Values from a Container
  • Changing a Memo Field from a Container
  • Changing a Field's Value from Global Variables
  • Updating from a Template Card
  • Adding a New Record to the Database
  • Multiple Database Update Technique
    
    
• 12. Deleting Records
  • Marking Records for Deletion
  • Unmarking Delete-marked Records
  • Physically Removing Marked Records
  • Physically Deleting Records
  • Determining if a Record is Deleted
  
  
• 13. Searching by Example (DBQuery)
  • Expression Constants
  • Field Names
  • Intrinsic Functions and Operators
  • Constructing Search Expressions
  • Clearing a Search Condition
    
    
• 14. Ultra-fast Searching with Indexes
  • Index Files Supported
  • When Indexes are Updated Automatically
  • Opening and Using Index Files
  • Finding a Record by Index
  • Building a Seek Expression
  • Getting Index File Information
  • Creating New Indexes and Updating Old Ones
  • Multi-Field Indexes
  • Intrinsic Functions in Indexes
  • You Must Index on a String Data Type
  
  
• 15. Full-Text Searching in Memo Fields
  • Easy Full-Text Search
  • Building a Complex Indexed Full-Text Search
  
  
• 16. Office-Quality Encryption
  • Encryption Limits
  • Standalone Encryption Functions
  • Dynamic, On-the-Fly Encryption Functions
  • Some Background on Implementation Choices
  
  
• 17. FileFlex Information Functions
  • Count Records
  • Calculate an Average
  • Calculate the Sum of a Field

Section IV: FileFlex Reference

• 18. FileFlex API Reference
  • Functions by Name
  • Functions by Category
  
  
• 19. Intrinsic Function Reference
  • Intrinsic Functions for DBSeek and DBQuery
  • Intrinsic Functions for DBQuery Only
  • Logical Operators (DBQuery Only)
  • String Constants in DBQuery Expressions
    
    
• 20. Result Code Reference
  • Positive Result Codes
  • Negative Result Codes
    
    
• 21. Direct Function Interface

Section V: Delivering FileFlex-based Solutions

• 22. Distributing FileFlex
  • FileFlex Runtime Edition
  • Special Note for Macromedia Director 5 Users
  • "R" and "Licensed Runtime Version" from DBVersion
  • DBCreate and DBCreateIndex Disabled
  • DBUse and DBUseIndex File Encryption Keys
  • Opening Distribution Doors Wide
    
    
• 23. FileFlex Distribution Terms and Conditions
  • Fees Paid--Lite Edition
  • Fees--Professional Edition
  • Terms and Conditions

Appendices

• A. FileFlex v2.0 Distribution License
• B. FileFlex Lite Distribution License
• C. FileFlex Order Form

Updates

• v2.0.1: FileFlex International WorldFlex Functions
  • Understanding Character-Level Sort Order
  • Custom Character Sort Orders
  • Creating a Single-Byte Custom Sort Order Table
  • Creating Single-Byte Sort Order Utility Scripts
  • Understanding Double-Byte Sort Order Tables
  • Creating Double-Byte Sort Order Tables
  • Tricks with Sort Order
  • Setting the Sort Order with FileFlex
  • Character Translation
  • Creating Character Translation Utility Scripts
  • Translating Characters Using FileFlex
  • Case Translation
  • Creating Case Translation Utility Scripts
  • Intelligent Case Conversion Using FileFlex
  • Standalone Intelligent Case Conversion Function